package com.ibm.cloud.banking.customer.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomerInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CustomerInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCustomerNoIsNull() {
            addCriterion("customer_no is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIsNotNull() {
            addCriterion("customer_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoEqualTo(String value) {
            addCriterion("customer_no =", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotEqualTo(String value) {
            addCriterion("customer_no <>", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThan(String value) {
            addCriterion("customer_no >", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThanOrEqualTo(String value) {
            addCriterion("customer_no >=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThan(String value) {
            addCriterion("customer_no <", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThanOrEqualTo(String value) {
            addCriterion("customer_no <=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLike(String value) {
            addCriterion("customer_no like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotLike(String value) {
            addCriterion("customer_no not like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIn(List<String> values) {
            addCriterion("customer_no in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotIn(List<String> values) {
            addCriterion("customer_no not in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoBetween(String value1, String value2) {
            addCriterion("customer_no between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotBetween(String value1, String value2) {
            addCriterion("customer_no not between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameIsNull() {
            addCriterion("customer_lastname is null");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameIsNotNull() {
            addCriterion("customer_lastname is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameEqualTo(String value) {
            addCriterion("customer_lastname =", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameNotEqualTo(String value) {
            addCriterion("customer_lastname <>", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameGreaterThan(String value) {
            addCriterion("customer_lastname >", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_lastname >=", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameLessThan(String value) {
            addCriterion("customer_lastname <", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameLessThanOrEqualTo(String value) {
            addCriterion("customer_lastname <=", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameLike(String value) {
            addCriterion("customer_lastname like", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameNotLike(String value) {
            addCriterion("customer_lastname not like", value, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameIn(List<String> values) {
            addCriterion("customer_lastname in", values, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameNotIn(List<String> values) {
            addCriterion("customer_lastname not in", values, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameBetween(String value1, String value2) {
            addCriterion("customer_lastname between", value1, value2, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerLastnameNotBetween(String value1, String value2) {
            addCriterion("customer_lastname not between", value1, value2, "customerLastname");
            return (Criteria) this;
        }

        public Criteria andCustomerMingIsNull() {
            addCriterion("customer_ming is null");
            return (Criteria) this;
        }

        public Criteria andCustomerMingIsNotNull() {
            addCriterion("customer_ming is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerMingEqualTo(String value) {
            addCriterion("customer_ming =", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingNotEqualTo(String value) {
            addCriterion("customer_ming <>", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingGreaterThan(String value) {
            addCriterion("customer_ming >", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingGreaterThanOrEqualTo(String value) {
            addCriterion("customer_ming >=", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingLessThan(String value) {
            addCriterion("customer_ming <", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingLessThanOrEqualTo(String value) {
            addCriterion("customer_ming <=", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingLike(String value) {
            addCriterion("customer_ming like", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingNotLike(String value) {
            addCriterion("customer_ming not like", value, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingIn(List<String> values) {
            addCriterion("customer_ming in", values, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingNotIn(List<String> values) {
            addCriterion("customer_ming not in", values, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingBetween(String value1, String value2) {
            addCriterion("customer_ming between", value1, value2, "customerMing");
            return (Criteria) this;
        }

        public Criteria andCustomerMingNotBetween(String value1, String value2) {
            addCriterion("customer_ming not between", value1, value2, "customerMing");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andNumberIsNull() {
            addCriterion("number is null");
            return (Criteria) this;
        }

        public Criteria andNumberIsNotNull() {
            addCriterion("number is not null");
            return (Criteria) this;
        }

        public Criteria andNumberEqualTo(String value) {
            addCriterion("number =", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotEqualTo(String value) {
            addCriterion("number <>", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThan(String value) {
            addCriterion("number >", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanOrEqualTo(String value) {
            addCriterion("number >=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThan(String value) {
            addCriterion("number <", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThanOrEqualTo(String value) {
            addCriterion("number <=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLike(String value) {
            addCriterion("number like", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotLike(String value) {
            addCriterion("number not like", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberIn(List<String> values) {
            addCriterion("number in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotIn(List<String> values) {
            addCriterion("number not in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberBetween(String value1, String value2) {
            addCriterion("number between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotBetween(String value1, String value2) {
            addCriterion("number not between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andIssueDateIsNull() {
            addCriterion("issue_date is null");
            return (Criteria) this;
        }

        public Criteria andIssueDateIsNotNull() {
            addCriterion("issue_date is not null");
            return (Criteria) this;
        }

        public Criteria andIssueDateEqualTo(Date value) {
            addCriterion("issue_date =", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateNotEqualTo(Date value) {
            addCriterion("issue_date <>", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateGreaterThan(Date value) {
            addCriterion("issue_date >", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateGreaterThanOrEqualTo(Date value) {
            addCriterion("issue_date >=", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateLessThan(Date value) {
            addCriterion("issue_date <", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateLessThanOrEqualTo(Date value) {
            addCriterion("issue_date <=", value, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateIn(List<Date> values) {
            addCriterion("issue_date in", values, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateNotIn(List<Date> values) {
            addCriterion("issue_date not in", values, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateBetween(Date value1, Date value2) {
            addCriterion("issue_date between", value1, value2, "issueDate");
            return (Criteria) this;
        }

        public Criteria andIssueDateNotBetween(Date value1, Date value2) {
            addCriterion("issue_date not between", value1, value2, "issueDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateIsNull() {
            addCriterion("invalid_date is null");
            return (Criteria) this;
        }

        public Criteria andInvalidDateIsNotNull() {
            addCriterion("invalid_date is not null");
            return (Criteria) this;
        }

        public Criteria andInvalidDateEqualTo(Date value) {
            addCriterion("invalid_date =", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateNotEqualTo(Date value) {
            addCriterion("invalid_date <>", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateGreaterThan(Date value) {
            addCriterion("invalid_date >", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateGreaterThanOrEqualTo(Date value) {
            addCriterion("invalid_date >=", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateLessThan(Date value) {
            addCriterion("invalid_date <", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateLessThanOrEqualTo(Date value) {
            addCriterion("invalid_date <=", value, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateIn(List<Date> values) {
            addCriterion("invalid_date in", values, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateNotIn(List<Date> values) {
            addCriterion("invalid_date not in", values, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateBetween(Date value1, Date value2) {
            addCriterion("invalid_date between", value1, value2, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andInvalidDateNotBetween(Date value1, Date value2) {
            addCriterion("invalid_date not between", value1, value2, "invalidDate");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeIsNull() {
            addCriterion("issuing_office is null");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeIsNotNull() {
            addCriterion("issuing_office is not null");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeEqualTo(String value) {
            addCriterion("issuing_office =", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeNotEqualTo(String value) {
            addCriterion("issuing_office <>", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeGreaterThan(String value) {
            addCriterion("issuing_office >", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeGreaterThanOrEqualTo(String value) {
            addCriterion("issuing_office >=", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeLessThan(String value) {
            addCriterion("issuing_office <", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeLessThanOrEqualTo(String value) {
            addCriterion("issuing_office <=", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeLike(String value) {
            addCriterion("issuing_office like", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeNotLike(String value) {
            addCriterion("issuing_office not like", value, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeIn(List<String> values) {
            addCriterion("issuing_office in", values, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeNotIn(List<String> values) {
            addCriterion("issuing_office not in", values, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeBetween(String value1, String value2) {
            addCriterion("issuing_office between", value1, value2, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andIssuingOfficeNotBetween(String value1, String value2) {
            addCriterion("issuing_office not between", value1, value2, "issuingOffice");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressIsNull() {
            addCriterion("zjdj_address is null");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressIsNotNull() {
            addCriterion("zjdj_address is not null");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressEqualTo(String value) {
            addCriterion("zjdj_address =", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressNotEqualTo(String value) {
            addCriterion("zjdj_address <>", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressGreaterThan(String value) {
            addCriterion("zjdj_address >", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressGreaterThanOrEqualTo(String value) {
            addCriterion("zjdj_address >=", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressLessThan(String value) {
            addCriterion("zjdj_address <", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressLessThanOrEqualTo(String value) {
            addCriterion("zjdj_address <=", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressLike(String value) {
            addCriterion("zjdj_address like", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressNotLike(String value) {
            addCriterion("zjdj_address not like", value, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressIn(List<String> values) {
            addCriterion("zjdj_address in", values, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressNotIn(List<String> values) {
            addCriterion("zjdj_address not in", values, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressBetween(String value1, String value2) {
            addCriterion("zjdj_address between", value1, value2, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andZjdjAddressNotBetween(String value1, String value2) {
            addCriterion("zjdj_address not between", value1, value2, "zjdjAddress");
            return (Criteria) this;
        }

        public Criteria andBirthDateIsNull() {
            addCriterion("birth_date is null");
            return (Criteria) this;
        }

        public Criteria andBirthDateIsNotNull() {
            addCriterion("birth_date is not null");
            return (Criteria) this;
        }

        public Criteria andBirthDateEqualTo(String value) {
            addCriterion("birth_date =", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateNotEqualTo(String value) {
            addCriterion("birth_date <>", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateGreaterThan(String value) {
            addCriterion("birth_date >", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateGreaterThanOrEqualTo(String value) {
            addCriterion("birth_date >=", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateLessThan(String value) {
            addCriterion("birth_date <", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateLessThanOrEqualTo(String value) {
            addCriterion("birth_date <=", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateLike(String value) {
            addCriterion("birth_date like", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateNotLike(String value) {
            addCriterion("birth_date not like", value, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateIn(List<String> values) {
            addCriterion("birth_date in", values, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateNotIn(List<String> values) {
            addCriterion("birth_date not in", values, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateBetween(String value1, String value2) {
            addCriterion("birth_date between", value1, value2, "birthDate");
            return (Criteria) this;
        }

        public Criteria andBirthDateNotBetween(String value1, String value2) {
            addCriterion("birth_date not between", value1, value2, "birthDate");
            return (Criteria) this;
        }

        public Criteria andGenderIsNull() {
            addCriterion("gender is null");
            return (Criteria) this;
        }

        public Criteria andGenderIsNotNull() {
            addCriterion("gender is not null");
            return (Criteria) this;
        }

        public Criteria andGenderEqualTo(String value) {
            addCriterion("gender =", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotEqualTo(String value) {
            addCriterion("gender <>", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThan(String value) {
            addCriterion("gender >", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThanOrEqualTo(String value) {
            addCriterion("gender >=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThan(String value) {
            addCriterion("gender <", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThanOrEqualTo(String value) {
            addCriterion("gender <=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLike(String value) {
            addCriterion("gender like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotLike(String value) {
            addCriterion("gender not like", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderIn(List<String> values) {
            addCriterion("gender in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotIn(List<String> values) {
            addCriterion("gender not in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderBetween(String value1, String value2) {
            addCriterion("gender between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotBetween(String value1, String value2) {
            addCriterion("gender not between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andNationalityIsNull() {
            addCriterion("nationality is null");
            return (Criteria) this;
        }

        public Criteria andNationalityIsNotNull() {
            addCriterion("nationality is not null");
            return (Criteria) this;
        }

        public Criteria andNationalityEqualTo(String value) {
            addCriterion("nationality =", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotEqualTo(String value) {
            addCriterion("nationality <>", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityGreaterThan(String value) {
            addCriterion("nationality >", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityGreaterThanOrEqualTo(String value) {
            addCriterion("nationality >=", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLessThan(String value) {
            addCriterion("nationality <", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLessThanOrEqualTo(String value) {
            addCriterion("nationality <=", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityLike(String value) {
            addCriterion("nationality like", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotLike(String value) {
            addCriterion("nationality not like", value, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityIn(List<String> values) {
            addCriterion("nationality in", values, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotIn(List<String> values) {
            addCriterion("nationality not in", values, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityBetween(String value1, String value2) {
            addCriterion("nationality between", value1, value2, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationalityNotBetween(String value1, String value2) {
            addCriterion("nationality not between", value1, value2, "nationality");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("nation is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("nation is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("nation =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("nation <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("nation >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("nation >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("nation <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("nation <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("nation like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("nation not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("nation in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("nation not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("nation between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("nation not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeIsNull() {
            addCriterion("customer_grade is null");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeIsNotNull() {
            addCriterion("customer_grade is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeEqualTo(String value) {
            addCriterion("customer_grade =", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeNotEqualTo(String value) {
            addCriterion("customer_grade <>", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeGreaterThan(String value) {
            addCriterion("customer_grade >", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_grade >=", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeLessThan(String value) {
            addCriterion("customer_grade <", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeLessThanOrEqualTo(String value) {
            addCriterion("customer_grade <=", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeLike(String value) {
            addCriterion("customer_grade like", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeNotLike(String value) {
            addCriterion("customer_grade not like", value, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeIn(List<String> values) {
            addCriterion("customer_grade in", values, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeNotIn(List<String> values) {
            addCriterion("customer_grade not in", values, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeBetween(String value1, String value2) {
            addCriterion("customer_grade between", value1, value2, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andCustomerGradeNotBetween(String value1, String value2) {
            addCriterion("customer_grade not between", value1, value2, "customerGrade");
            return (Criteria) this;
        }

        public Criteria andJingneiIsNull() {
            addCriterion("jingnei is null");
            return (Criteria) this;
        }

        public Criteria andJingneiIsNotNull() {
            addCriterion("jingnei is not null");
            return (Criteria) this;
        }

        public Criteria andJingneiEqualTo(String value) {
            addCriterion("jingnei =", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiNotEqualTo(String value) {
            addCriterion("jingnei <>", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiGreaterThan(String value) {
            addCriterion("jingnei >", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiGreaterThanOrEqualTo(String value) {
            addCriterion("jingnei >=", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiLessThan(String value) {
            addCriterion("jingnei <", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiLessThanOrEqualTo(String value) {
            addCriterion("jingnei <=", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiLike(String value) {
            addCriterion("jingnei like", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiNotLike(String value) {
            addCriterion("jingnei not like", value, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiIn(List<String> values) {
            addCriterion("jingnei in", values, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiNotIn(List<String> values) {
            addCriterion("jingnei not in", values, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiBetween(String value1, String value2) {
            addCriterion("jingnei between", value1, value2, "jingnei");
            return (Criteria) this;
        }

        public Criteria andJingneiNotBetween(String value1, String value2) {
            addCriterion("jingnei not between", value1, value2, "jingnei");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andContactAddressIsNull() {
            addCriterion("contact_address is null");
            return (Criteria) this;
        }

        public Criteria andContactAddressIsNotNull() {
            addCriterion("contact_address is not null");
            return (Criteria) this;
        }

        public Criteria andContactAddressEqualTo(String value) {
            addCriterion("contact_address =", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressNotEqualTo(String value) {
            addCriterion("contact_address <>", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressGreaterThan(String value) {
            addCriterion("contact_address >", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressGreaterThanOrEqualTo(String value) {
            addCriterion("contact_address >=", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressLessThan(String value) {
            addCriterion("contact_address <", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressLessThanOrEqualTo(String value) {
            addCriterion("contact_address <=", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressLike(String value) {
            addCriterion("contact_address like", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressNotLike(String value) {
            addCriterion("contact_address not like", value, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressIn(List<String> values) {
            addCriterion("contact_address in", values, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressNotIn(List<String> values) {
            addCriterion("contact_address not in", values, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressBetween(String value1, String value2) {
            addCriterion("contact_address between", value1, value2, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andContactAddressNotBetween(String value1, String value2) {
            addCriterion("contact_address not between", value1, value2, "contactAddress");
            return (Criteria) this;
        }

        public Criteria andDistrictCardIsNull() {
            addCriterion("district_card is null");
            return (Criteria) this;
        }

        public Criteria andDistrictCardIsNotNull() {
            addCriterion("district_card is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictCardEqualTo(String value) {
            addCriterion("district_card =", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardNotEqualTo(String value) {
            addCriterion("district_card <>", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardGreaterThan(String value) {
            addCriterion("district_card >", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardGreaterThanOrEqualTo(String value) {
            addCriterion("district_card >=", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardLessThan(String value) {
            addCriterion("district_card <", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardLessThanOrEqualTo(String value) {
            addCriterion("district_card <=", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardLike(String value) {
            addCriterion("district_card like", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardNotLike(String value) {
            addCriterion("district_card not like", value, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardIn(List<String> values) {
            addCriterion("district_card in", values, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardNotIn(List<String> values) {
            addCriterion("district_card not in", values, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardBetween(String value1, String value2) {
            addCriterion("district_card between", value1, value2, "districtCard");
            return (Criteria) this;
        }

        public Criteria andDistrictCardNotBetween(String value1, String value2) {
            addCriterion("district_card not between", value1, value2, "districtCard");
            return (Criteria) this;
        }

        public Criteria andLocalCityIsNull() {
            addCriterion("local_city is null");
            return (Criteria) this;
        }

        public Criteria andLocalCityIsNotNull() {
            addCriterion("local_city is not null");
            return (Criteria) this;
        }

        public Criteria andLocalCityEqualTo(String value) {
            addCriterion("local_city =", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityNotEqualTo(String value) {
            addCriterion("local_city <>", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityGreaterThan(String value) {
            addCriterion("local_city >", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityGreaterThanOrEqualTo(String value) {
            addCriterion("local_city >=", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityLessThan(String value) {
            addCriterion("local_city <", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityLessThanOrEqualTo(String value) {
            addCriterion("local_city <=", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityLike(String value) {
            addCriterion("local_city like", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityNotLike(String value) {
            addCriterion("local_city not like", value, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityIn(List<String> values) {
            addCriterion("local_city in", values, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityNotIn(List<String> values) {
            addCriterion("local_city not in", values, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityBetween(String value1, String value2) {
            addCriterion("local_city between", value1, value2, "localCity");
            return (Criteria) this;
        }

        public Criteria andLocalCityNotBetween(String value1, String value2) {
            addCriterion("local_city not between", value1, value2, "localCity");
            return (Criteria) this;
        }

        public Criteria andSupplementIsNull() {
            addCriterion("supplement is null");
            return (Criteria) this;
        }

        public Criteria andSupplementIsNotNull() {
            addCriterion("supplement is not null");
            return (Criteria) this;
        }

        public Criteria andSupplementEqualTo(String value) {
            addCriterion("supplement =", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementNotEqualTo(String value) {
            addCriterion("supplement <>", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementGreaterThan(String value) {
            addCriterion("supplement >", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementGreaterThanOrEqualTo(String value) {
            addCriterion("supplement >=", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementLessThan(String value) {
            addCriterion("supplement <", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementLessThanOrEqualTo(String value) {
            addCriterion("supplement <=", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementLike(String value) {
            addCriterion("supplement like", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementNotLike(String value) {
            addCriterion("supplement not like", value, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementIn(List<String> values) {
            addCriterion("supplement in", values, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementNotIn(List<String> values) {
            addCriterion("supplement not in", values, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementBetween(String value1, String value2) {
            addCriterion("supplement between", value1, value2, "supplement");
            return (Criteria) this;
        }

        public Criteria andSupplementNotBetween(String value1, String value2) {
            addCriterion("supplement not between", value1, value2, "supplement");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreatOrganIsNull() {
            addCriterion("creat_organ is null");
            return (Criteria) this;
        }

        public Criteria andCreatOrganIsNotNull() {
            addCriterion("creat_organ is not null");
            return (Criteria) this;
        }

        public Criteria andCreatOrganEqualTo(String value) {
            addCriterion("creat_organ =", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganNotEqualTo(String value) {
            addCriterion("creat_organ <>", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganGreaterThan(String value) {
            addCriterion("creat_organ >", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganGreaterThanOrEqualTo(String value) {
            addCriterion("creat_organ >=", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganLessThan(String value) {
            addCriterion("creat_organ <", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganLessThanOrEqualTo(String value) {
            addCriterion("creat_organ <=", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganLike(String value) {
            addCriterion("creat_organ like", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganNotLike(String value) {
            addCriterion("creat_organ not like", value, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganIn(List<String> values) {
            addCriterion("creat_organ in", values, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganNotIn(List<String> values) {
            addCriterion("creat_organ not in", values, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganBetween(String value1, String value2) {
            addCriterion("creat_organ between", value1, value2, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatOrganNotBetween(String value1, String value2) {
            addCriterion("creat_organ not between", value1, value2, "creatOrgan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanIsNull() {
            addCriterion("creat_guiyuan is null");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanIsNotNull() {
            addCriterion("creat_guiyuan is not null");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanEqualTo(String value) {
            addCriterion("creat_guiyuan =", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanNotEqualTo(String value) {
            addCriterion("creat_guiyuan <>", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanGreaterThan(String value) {
            addCriterion("creat_guiyuan >", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanGreaterThanOrEqualTo(String value) {
            addCriterion("creat_guiyuan >=", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanLessThan(String value) {
            addCriterion("creat_guiyuan <", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanLessThanOrEqualTo(String value) {
            addCriterion("creat_guiyuan <=", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanLike(String value) {
            addCriterion("creat_guiyuan like", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanNotLike(String value) {
            addCriterion("creat_guiyuan not like", value, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanIn(List<String> values) {
            addCriterion("creat_guiyuan in", values, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanNotIn(List<String> values) {
            addCriterion("creat_guiyuan not in", values, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanBetween(String value1, String value2) {
            addCriterion("creat_guiyuan between", value1, value2, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCreatGuiyuanNotBetween(String value1, String value2) {
            addCriterion("creat_guiyuan not between", value1, value2, "creatGuiyuan");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIsNull() {
            addCriterion("customer_group is null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIsNotNull() {
            addCriterion("customer_group is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupEqualTo(String value) {
            addCriterion("customer_group =", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNotEqualTo(String value) {
            addCriterion("customer_group <>", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupGreaterThan(String value) {
            addCriterion("customer_group >", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupGreaterThanOrEqualTo(String value) {
            addCriterion("customer_group >=", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupLessThan(String value) {
            addCriterion("customer_group <", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupLessThanOrEqualTo(String value) {
            addCriterion("customer_group <=", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupLike(String value) {
            addCriterion("customer_group like", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNotLike(String value) {
            addCriterion("customer_group not like", value, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIn(List<String> values) {
            addCriterion("customer_group in", values, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNotIn(List<String> values) {
            addCriterion("customer_group not in", values, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupBetween(String value1, String value2) {
            addCriterion("customer_group between", value1, value2, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNotBetween(String value1, String value2) {
            addCriterion("customer_group not between", value1, value2, "customerGroup");
            return (Criteria) this;
        }

        public Criteria andShardingIdIsNull() {
            addCriterion("sharding_id is null");
            return (Criteria) this;
        }

        public Criteria andShardingIdIsNotNull() {
            addCriterion("sharding_id is not null");
            return (Criteria) this;
        }

        public Criteria andShardingIdEqualTo(Integer value) {
            addCriterion("sharding_id =", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdNotEqualTo(Integer value) {
            addCriterion("sharding_id <>", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdGreaterThan(Integer value) {
            addCriterion("sharding_id >", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("sharding_id >=", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdLessThan(Integer value) {
            addCriterion("sharding_id <", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdLessThanOrEqualTo(Integer value) {
            addCriterion("sharding_id <=", value, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdIn(List<Integer> values) {
            addCriterion("sharding_id in", values, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdNotIn(List<Integer> values) {
            addCriterion("sharding_id not in", values, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdBetween(Integer value1, Integer value2) {
            addCriterion("sharding_id between", value1, value2, "shardingId");
            return (Criteria) this;
        }

        public Criteria andShardingIdNotBetween(Integer value1, Integer value2) {
            addCriterion("sharding_id not between", value1, value2, "shardingId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}